Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	2773
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	303.4 KiB
Average record size in memory	112.0 B

Variable types

Numeric	14

Alerts

`gross_revenue` is highly correlated with `invoice_no` and 4 other fields	High correlation
`invoice_no` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`avg_quantity` is highly correlated with `avg_ticket` and 2 other fields	High correlation
`total_quantity` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`avg_ticket` is highly correlated with `avg_quantity` and 2 other fields	High correlation
`avg_recency_days` is highly correlated with `df_index`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`avg_un_basket_size` is highly correlated with `avg_quantity` and 2 other fields	High correlation
`stock_code` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qty_returns` is highly correlated with `gross_revenue` and 6 other fields	High correlation
`df_index` is highly correlated with `avg_recency_days`	High correlation
`avg_ticket` is highly skewed (γ1 = 27.67812665)	Skewed
`frequency` is highly skewed (γ1 = 46.07732187)	Skewed
`qty_returns` is highly skewed (γ1 = 21.6260127)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 33 (1.2%) zeros	Zeros
`qty_returns` has 1481 (53.4%) zeros	Zeros

Reproduction

Analysis started	2022-10-21 22:35:24.238604
Analysis finished	2022-10-21 22:35:59.420288
Duration	35.18 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	2773
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2250.579517

Minimum	0
Maximum	5695
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	181.6
Q1	901
median	2061
Q3	3411
95-th percentile	4958.4
Maximum	5695
Range	5695
Interquartile range (IQR)	2510

Descriptive statistics

Standard deviation	1526.372877
Coefficient of variation (CV)	0.6782132625
Kurtosis	-0.9560471528
Mean	2250.579517
Median Absolute Deviation (MAD)	1241
Skewness	0.3799089199
Sum	6240857
Variance	2329814.159
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
2910	1	< 0.1%
2896	1	< 0.1%
2897	1	< 0.1%
2900	1	< 0.1%
2901	1	< 0.1%
2905	1	< 0.1%
2906	1	< 0.1%
2907	1	< 0.1%
2908	1	< 0.1%
Other values (2763)	2763	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5695	1	< 0.1%
5685	1	< 0.1%
5679	1	< 0.1%
5654	1	< 0.1%
5648	1	< 0.1%
5637	1	< 0.1%
5636	1	< 0.1%
5620	1	< 0.1%
5619	1	< 0.1%
5610	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2773
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15285.28128

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	12347
5-th percentile	12626.6
Q1	13815
median	15241
Q3	16780
95-th percentile	17950.4
Maximum	18287
Range	5940
Interquartile range (IQR)	2965

Descriptive statistics

Standard deviation	1715.152588
Coefficient of variation (CV)	0.1122094226
Kurtosis	-1.207029283
Mean	15285.28128
Median Absolute Deviation (MAD)	1484
Skewness	0.0166125065
Sum	42386085
Variance	2941748.399
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
14482	1	< 0.1%
17058	1	< 0.1%
17704	1	< 0.1%
16933	1	< 0.1%
13772	1	< 0.1%
16249	1	< 0.1%
14198	1	< 0.1%
13989	1	< 0.1%
17930	1	< 0.1%
Other values (2763)	2763	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2759
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2845.044446

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.548
Q1	628.78
median	1169.94
Q3	2424.04
95-th percentile	7490.982
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1795.26

Descriptive statistics

Standard deviation	10466.82835
Coefficient of variation (CV)	3.678968308
Kurtosis	372.786099
Mean	2845.044446
Median Absolute Deviation (MAD)	687.93
Skewness	17.09734698
Sum	7889308.25
Variance	109554495.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1025.44	2	0.1%
745.06	2	0.1%
889.93	2	0.1%
734.94	2	0.1%
331	2	0.1%
1314.45	2	0.1%
379.65	2	0.1%
1353.74	2	0.1%
598.2	2	0.1%
1078.96	2	0.1%
Other values (2749)	2753	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

recency_days
Real number (ℝ_≥0)

ZEROS

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.64731338

Minimum	0
Maximum	372
Zeros	33
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.42352582
Coefficient of variation (CV)	1.207886513
Kurtosis	3.430442793
Mean	56.64731338
Median Absolute Deviation (MAD)	23
Skewness	1.898015296
Sum	157083
Variance	4681.778886
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	87	3.1%
2	85	3.1%
3	85	3.1%
8	76	2.7%
10	67	2.4%
9	66	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2026	73.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	1.2%
1	99	3.6%
2	85	3.1%
3	85	3.1%
4	87	3.1%
5	43	1.6%
7	65	2.3%
8	76	2.7%
9	66	2.4%
10	67	2.4%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%
333	2	0.1%
330	1	< 0.1%

invoice_no
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.054814281

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.072771138
Coefficient of variation (CV)	1.498439212
Kurtosis	183.9078799
Mean	6.054814281
Median Absolute Deviation (MAD)	2
Skewness	10.62384214
Sum	16790
Variance	82.31517613
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	779	28.1%
3	499	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	779	28.1%
3	499	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

avg_quantity
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2599
Distinct (%)	93.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.10229044

Minimum	1
Maximum	2000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	2.559069246
Q1	6.364583333
median	10.33333333
Q3	15.02797203
95-th percentile	47.43011236
Maximum	2000
Range	1999
Interquartile range (IQR)	8.663388695

Descriptive statistics

Standard deviation	76.47130626
Coefficient of variation (CV)	3.804109112
Kurtosis	385.7554308
Mean	20.10229044
Median Absolute Deviation (MAD)	4.266666667
Skewness	17.64458645
Sum	55743.6514
Variance	5847.860681
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	8	0.3%
9.333333333	7	0.3%
11	6	0.2%
10.4	4	0.1%
18	4	0.1%
12	4	0.1%
12.5	4	0.1%
6.5	4	0.1%
9	4	0.1%
23.33333333	3	0.1%
Other values (2589)	2725	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
1.052631579	1	< 0.1%
1.055555556	1	< 0.1%
1.131578947	1	< 0.1%
1.21875	1	< 0.1%
1.257142857	1	< 0.1%
1.260416667	1	< 0.1%
1.28	1	< 0.1%
1.376146789	1	< 0.1%
1.39408867	1	< 0.1%

Value	Count	Frequency (%)
2000	1	< 0.1%
1802.8	1	< 0.1%
1756.5	1	< 0.1%
1009.5	1	< 0.1%
740	1	< 0.1%
715.2	1	< 0.1%
664.6153846	1	< 0.1%
657	1	< 0.1%
600	1	< 0.1%
541.8888889	1	< 0.1%

total_quantity
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1638
Distinct (%)	59.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1671.783988

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	119.6
Q1	330
median	704
Q3	1478
95-th percentile	4614
Maximum	196844
Range	196842
Interquartile range (IQR)	1148

Descriptive statistics

Standard deviation	5890.699162
Coefficient of variation (CV)	3.523600658
Kurtosis	485.4627718
Mean	1671.783988
Median Absolute Deviation (MAD)	452
Skewness	18.17697463
Sum	4635857
Variance	34700336.61
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	8	0.3%
246	8	0.3%
200	7	0.3%
260	7	0.3%
1200	7	0.3%
300	7	0.3%
394	7	0.3%
493	7	0.3%
516	7	0.3%
Other values (1628)	2697	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%
33	2	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%
50255	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	2771
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.10411414

Minimum	2.150588235
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.852453809
Q1	12.41668
median	17.94081081
Q3	25.02555556
95-th percentile	87.75747368
Maximum	4453.43
Range	4451.279412
Interquartile range (IQR)	12.60887556

Descriptive statistics

Standard deviation	107.6316856
Coefficient of variation (CV)	3.352582324
Kurtosis	1054.619311
Mean	32.10411414
Median Absolute Deviation (MAD)	6.337289189
Skewness	27.67812665
Sum	89024.70852
Variance	11584.57974
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
4.162	2	0.1%
25.6761194	1	< 0.1%
44.95564103	1	< 0.1%
32.59775	1	< 0.1%
19.03048387	1	< 0.1%
28.55451613	1	< 0.1%
12.80068182	1	< 0.1%
6.396214689	1	< 0.1%
26.08797101	1	< 0.1%
Other values (2761)	2761	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%
602.4531323	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	305
Distinct (%)	11.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.50126217

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	66.57709146
Coefficient of variation (CV)	0.8481021785
Kurtosis	3.683144872
Mean	78.50126217
Median Absolute Deviation (MAD)	30
Skewness	1.83060598
Sum	217684
Variance	4432.509107
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35	40	1.4%
70	39	1.4%
55	36	1.3%
21	36	1.3%
31	36	1.3%
45	36	1.3%
25	35	1.3%
46	34	1.2%
38	33	1.2%
26	33	1.2%
Other values (295)	2415	87.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.3%
2	5	0.2%
3	8	0.3%
4	8	0.3%
5	5	0.2%
6	8	0.3%
7	12	0.4%
8	12	0.4%
9	10	0.4%
10	18	0.6%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	1225
Distinct (%)	44.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.04971312176

Minimum	0.005449591281
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.008746355685
Q1	0.01578947368
median	0.0243902439
Q3	0.04166666667
95-th percentile	0.1153846154
Maximum	17
Range	16.99455041
Interquartile range (IQR)	0.02587719298

Descriptive statistics

Standard deviation	0.3376551076
Coefficient of variation (CV)	6.792072107
Kurtosis	2295.704265
Mean	0.04971312176
Median Absolute Deviation (MAD)	0.01069161377
Skewness	46.07732187
Sum	137.8544866
Variance	0.1140109717
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0625	18	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.6%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.02941176471	14	0.5%
0.03448275862	14	0.5%
0.01923076923	13	0.5%
0.02564102564	13	0.5%
0.02127659574	13	0.5%
Other values (1215)	2625	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	1	< 0.1%
1.142857143	1	< 0.1%
1	8	0.3%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

qty_returns
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	204
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.97367472

Minimum	0
Maximum	9014
Zeros	1481
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	96.8
Maximum	9014
Range	9014
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	290.7142899
Coefficient of variation (CV)	8.312374729
Kurtosis	571.7456843
Mean	34.97367472
Median Absolute Deviation (MAD)	0
Skewness	21.6260127
Sum	96982
Variance	84514.79837
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
6	63	2.3%
5	55	2.0%
12	45	1.6%
8	39	1.4%
9	38	1.4%
Other values (194)	652	23.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
5	55	2.0%
6	63	2.3%
7	38	1.4%
8	39	1.4%
9	38	1.4%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1937
Distinct (%)	69.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	231.446111

Minimum	1
Maximum	6009.333333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	45
Q1	103.3333333
median	172
Q3	278.2
95-th percentile	585.7
Maximum	6009.333333
Range	6008.333333
Interquartile range (IQR)	174.8666667

Descriptive statistics

Standard deviation	261.7394008
Coefficient of variation (CV)	1.130887012
Kurtosis	115.4829522
Mean	231.446111
Median Absolute Deviation (MAD)	81
Skewness	7.715252816
Sum	641800.0657
Variance	68507.51392
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
86	9	0.3%
60	8	0.3%
75	8	0.3%
208	7	0.3%
105	7	0.3%
73	7	0.3%
136	7	0.3%
82	7	0.3%
197	7	0.3%
Other values (1927)	2695	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%
11.875	1	< 0.1%

Value	Count	Frequency (%)
6009.333333	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%
1903.5	1	< 0.1%
1866.933333	1	< 0.1%

avg_un_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	897
Distinct (%)	32.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.14109332

Minimum	0.2
Maximum	177
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.545454545
median	13.5
Q3	22
95-th percentile	45.1
Maximum	177
Range	176.8
Interquartile range (IQR)	14.45454545

Descriptive statistics

Standard deviation	14.26277434
Coefficient of variation (CV)	0.832080782
Kurtosis	10.00830576
Mean	17.14109332
Median Absolute Deviation (MAD)	6.666666667
Skewness	2.24639468
Sum	47532.25179
Variance	203.4267318
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	34	1.2%
13	33	1.2%
9	32	1.2%
16	32	1.2%
7	32	1.2%
12	30	1.1%
14	29	1.0%
6	29	1.0%
17	29	1.0%
18.5	29	1.0%
Other values (887)	2464	88.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
177	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%
93.33333333	1	< 0.1%
89.625	1	< 0.1%
87	1	< 0.1%
85.66666667	1	< 0.1%

stock_code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	467
Distinct (%)	16.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	129.7890371

Minimum	2
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	10
Q1	34
median	72
Q3	143
95-th percentile	400.2
Maximum	7838
Range	7836
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	277.8250768
Coefficient of variation (CV)	2.140589706
Kurtosis	336.7416641
Mean	129.7890371
Median Absolute Deviation (MAD)	45
Skewness	15.34716552
Sum	359905
Variance	77186.7733
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	38	1.4%
35	34	1.2%
27	30	1.1%
26	30	1.1%
29	30	1.1%
15	27	1.0%
19	27	1.0%
25	27	1.0%
31	27	1.0%
33	26	0.9%
Other values (457)	2477	89.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	11	0.4%
3	12	0.4%
4	16	0.6%
5	16	0.6%
6	24	0.9%
7	14	0.5%
8	13	0.5%
9	19	0.7%
10	19	0.7%
11	23	0.8%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	invoice_no	avg_quantity	total_quantity	avg_ticket	avg_recency_days	frequency	qty_returns	avg_basket_size	avg_un_basket_size	stock_code
0	0	17850	5391.21	372.0	34.0	5.835017	1733.0	18.152222	1.0	17.000000	40.0	50.970588	0.617647	297.0
1	1	13047	3232.59	56.0	9.0	8.128655	1390.0	18.904035	52.0	0.028302	35.0	154.444444	11.666667	171.0
2	2	12583	6705.38	2.0	15.0	21.672414	5028.0	28.902500	26.0	0.040323	50.0	335.200000	7.600000	232.0
3	3	13748	948.25	95.0	5.0	15.678571	439.0	33.866071	92.0	0.017921	0.0	87.800000	4.800000	28.0
4	4	15100	876.00	333.0	3.0	26.666667	80.0	292.000000	20.0	0.073171	22.0	26.666667	0.333333	3.0
5	5	15291	4623.30	25.0	14.0	20.607843	2102.0	45.326471	26.0	0.040115	29.0	150.142857	4.357143	102.0
6	6	14688	5630.87	7.0	21.0	11.073394	3621.0	17.219786	19.0	0.057221	399.0	172.428571	7.047619	327.0
7	7	17809	5411.91	16.0	12.0	33.721311	2057.0	88.719836	39.0	0.033520	41.0	171.416667	3.833333	61.0
8	8	15311	60767.90	0.0	91.0	16.054645	38194.0	25.543464	4.0	0.243316	474.0	419.714286	6.230769	2379.0
9	9	16098	2005.63	87.0	7.0	9.149254	613.0	29.934776	47.0	0.024390	0.0	87.571429	4.857143	67.0

Last rows

	df_index	customer_id	gross_revenue	recency_days	invoice_no	avg_quantity	total_quantity	avg_ticket	avg_recency_days	frequency	qty_returns	avg_basket_size	avg_un_basket_size	stock_code
2763	5610	17290	525.24	3.0	2.0	3.960784	404.0	5.149412	13.0	0.142857	0.0	202.000000	46.000000	102.0
2764	5619	14785	77.40	10.0	2.0	28.000000	84.0	25.800000	5.0	0.333333	0.0	42.000000	1.000000	3.0
2765	5620	17254	272.44	4.0	2.0	2.250000	252.0	2.432500	11.0	0.166667	0.0	126.000000	50.000000	112.0
2766	5636	17232	421.52	2.0	2.0	5.638889	203.0	11.708889	12.0	0.153846	0.0	101.500000	15.000000	36.0
2767	5637	17468	137.00	10.0	2.0	23.200000	116.0	27.400000	4.0	0.400000	0.0	58.000000	2.500000	5.0
2768	5648	13596	697.04	5.0	2.0	2.445783	406.0	4.199036	7.0	0.250000	0.0	203.000000	66.500000	166.0
2769	5654	14893	1237.85	9.0	2.0	10.945205	799.0	16.956849	2.0	0.666667	0.0	399.500000	36.000000	73.0
2770	5679	14126	706.13	7.0	3.0	33.866667	508.0	47.075333	3.0	0.750000	50.0	169.333333	4.666667	15.0
2771	5685	13521	1092.39	1.0	3.0	1.685057	733.0	2.511241	4.0	0.300000	0.0	244.333333	104.000000	435.0
2772	5695	15060	301.84	8.0	4.0	2.183333	262.0	2.515333	1.0	2.000000	0.0	65.500000	20.000000	120.0

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows